-
Re: sum the revenue by every 3 months?
@Ozu you put MONTH())-2 you forgot to put MONTH(TODAY())-21 · -
Re: I've been searching for a way to make the bottom scroll bar show, it vanishes unless I scroll down.
I've had that issue also. The best way to work around it is to use SHIFT + mouse scroll to move left and right. I agree it's very frustrating and not sure why it happens on some sheets.1 · -
Re: April Question of the Month - Join the conversation and receive a badge
I think Smartsheet needs to focus more on the basics instead of worrying about AI. There are so many features and suggestions that I believe take precedence over AI. Here are some items that I would …2 · -
Re: Help with IF, OR, NOT, ISBLANK
I would just do: =if(or([WHS: Enter Date Received]@row<>"",[WHS: Enter Lot]@row<>"",[IQA: Inspector Email]@row<>""),1,0)1 · -
Re: Help with IF, OR, NOT, ISBLANK
Also I think the only issue with how you did it was the last 2 )) I think you need to end your formula like this: ([IQA: Inspector Email]@row))), 1, 0)1 ·